select a.c_accountcode,a.d_date,a.Opening,a.closing,abs(a.closing-a.Opening) dif_acbal ,abs(b.differ) dif_genledg from account_balance a, 
	(select c_accountcode,sum(m_dramount-m_cramount) differ from general_ledger
	where d_transactiondate = '26 jun 2006' group by c_accountcode) b
where a.c_accountcode=b.c_accountcode and a.d_date = '26 jun 2006'
and abs(a.Opening-a.closing) <> abs(a.Opening-a.closing)




//************************trial balance checque***********************************//
select a.c_accountcode,a.d_date,a.Opening,a.closing,abs(a.closing-a.Opening) dif_acbal ,abs(b.differ) dif_genledg from account_balance a, 
	(select c_accountcode,d_transactiondate,sum(m_dramount-m_cramount) differ from general_ledger
	where finyr='13' and d_cancelldate = '01 jan 1900'  group by c_accountcode,d_transactiondate) b
where a.finyr='13' and a.c_accountcode=b.c_accountcode and a.d_date = b.d_transactiondate
and abs(a.Opening-a.closing) <> abs(b.differ) order by a.c_accountcode


Same query with left join 

select c_accountcode,d_date,Opening,closing,dif_acbal, isnull(c.dif_genledg,0) dif_genledg into #bal_ledger_ljoin from (
select a.c_accountcode,a.d_date,a.Opening,a.closing,abs(a.closing-a.Opening) dif_acbal ,abs(b.differ) dif_genledg 
from 	account_balance a, 
	(select c_accountcode,d_transactiondate,sum(m_dramount-m_cramount) differ from general_ledger
	where finyr='14' and d_cancelldate = '01 jan 1900'  group by c_accountcode,d_transactiondate) b
where a.finyr='14' and a.c_accountcode *= b.c_accountcode and a.d_date *= b.d_transactiondate ) c

select * from #bal_ledger_ljoin where dif_acbal <> dif_genledg

************************************************************************************


//*******************************UPDATE**********************//
select * from general_ledger where finyr='13' and c_transactionno='RR00001510' and c_accountcode='121717'
begin tran
update general_ledger  set d_chequedate= '30 jan 2006' where finyr='13' and c_transactionno='RR00001510' and c_accountcode='121717' 
commit
**************************************************************


IV00000001     
IV00000003     
IV00000005     
IV00000011     
IV00000012     
IV00000016     
IV00000020     
IV00000045     
IV00000065     
IV00000068     
IV00000075     
IV00000085     
IV00000086     
IV00000104     
IV00000107     
IV00000108     
IV00000111     
IV00000117     
IV00000122     
IV00000133     
IV00000138     
IV00000141     
IV00000149     
IV00000150     
IV00000155     
IV00000159     
IV00000160     
IV00000173     
IV00000188     
IV00000211     
IV00000217     
IV00000229     
IV00000238     
IV00000252     
IV00000266     
IV00000276     
IV00000293     
IV00000299     
IV00000305     
IV00000311     
IV00000314     
IV00000316     
IV00000322     
IV00000349     
IV00000363     
IV00000365     
IV00000370     
IV00000389     
IV00000390     
IV00000391     
IV00000397     
IV00000410     
IV00000414     
IV00000423     
IV00000435     
IV00000439     
IV00000447     
IV00000455     
IV00000465     
IV00000483     
IV00000488     
IV00000497     
IV00000501     
IV00000502     
IV00000506     
IV00000508     
IV00000509     
IV00000518     
IV00000530     
IV00000531     
IV00000541     
IV00000547     
IV00000551     
IV00000553     
IV00000560     
IV00000575     
IV00000579     
IV00000589     
IV00000594     
IV00000600     
IV00000606     
IV00000608     
IV00000609     
IV00000615     
IV00000616     
IV00000619     
IV00000624     
IV00000632     
IV00000640     
IV00000658     
IV00000664     
IV00000681     
IV00000682     
IV00000714     
IV00000722     
IV00000726     
IV00000727     
IV00000745     
IV00000746     
IV00000758     
IV00000760     
IV00000769     
IV00000778     
IV00000788     
IV00000790     
IV00000791     
IV00000800     
IV00000815     


